﻿using Microsoft.EntityFrameworkCore.Migrations;

#nullable disable

namespace StatsData.Data.Migrations
{
    public partial class add_all_en_label : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.AddColumn<string>(
                name: "LINE_NAME",
                table: "T_OWE",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "LINE_NAME_EN",
                table: "T_OWE",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "DATE_TYPE_EN",
                table: "T_KPI_STATIS",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "LINE_NAME",
                table: "T_BAD",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "LINE_NAME_EN",
                table: "T_BAD",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "PRODURE_NAME_EN",
                table: "T_BAD",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "I_REMARK_EN",
                table: "T_ANDON_DATA",
                type: "NVARCHAR2(600)",
                maxLength: 600,
                nullable: true);
        }

        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropColumn(
                name: "LINE_NAME",
                table: "T_OWE");

            migrationBuilder.DropColumn(
                name: "LINE_NAME_EN",
                table: "T_OWE");

            migrationBuilder.DropColumn(
                name: "DATE_TYPE_EN",
                table: "T_KPI_STATIS");

            migrationBuilder.DropColumn(
                name: "LINE_NAME",
                table: "T_BAD");

            migrationBuilder.DropColumn(
                name: "LINE_NAME_EN",
                table: "T_BAD");

            migrationBuilder.DropColumn(
                name: "PRODURE_NAME_EN",
                table: "T_BAD");

            migrationBuilder.DropColumn(
                name: "I_REMARK_EN",
                table: "T_ANDON_DATA");
        }
    }
}
